The delete SQL statement allows us to remove existing records from a table. We need to specify which records to delete by using a where clause as in the following example.

-- John Smith is fired
delete from Database_test_IB1.employee 
where last_name = 'Smith' and first_name = 'John';

BigQuery returns an error if you omit the where clause in the delete.